The invoice data contain the data for a central place or the summed up invoice data for an address per line. The columns of a data line are separated by semicolons.

The 1st line of the file also contains a semicolon separated list of the column names to describe the file contents. The sequence of the columns is arbitrary; for the interpretation of the columns by the sisHYD import, however, the following column names must be used:

• Kunde – Unique designation of the customer (e. g. for special customers or reception points without address)
• Strasse – Street name of the consumption place and/or consumption address
• Hausnummer – House number of the consumption place and/or consumption address
• PLZ – POSTAL/ZIP CODE: Postal/zip code of the consumption place and/or consumption address
• Nennleistung – Connected load [kW]
• Nennmassenstrom – Nominal mass flow of the consumption place and/or consumption address [kg/s]
• Nennvolumenstrom Nominal mass flow of the consumption place and/or consumption address [m³/h]
• Wärme1 – Amount of heat taken in the last year [kWh]
• Wärme2 – Amount of heat taken in the year before last [kWh]
• Menge1 – Quantity taken in previous year [kg]
• Menge2 – Quantity taken in previous year [kg]
• Volumen1 – Volume taken in previous year [m³]
• Volumen2 – Volume taken in previous year [m³]
• Gruppe – Consumer category for the allocation of the load behavior (=allocation to a sisHYD consumer group)
• OrgGruppe – Organisatory group allocation of the consumption place (=allocation to a sisHYD org group) – no longer used

The following columns must be present for the import to sisHYD:

• either the column Customer for the customer name
• or the columns Road and Street number
• (if there double street names in several supplied places, also the postal/zip code)
• as well as at least one consumption value

The allocations of the customer data can also be changed with the attributes Group and OrgGroup. However, before the import of the customer data, the appropriate consumer groups (for the attribute group) and/or org groups (for the attribute OrgGruppe) must have been created in sisHYD. Further columns which cannot be interpreted by sisHYD can also be contained in the file; these columns are simply overlooked.

Example of an invoice data file:

Kunde;Strasse;Hausnummer;Wärme1;Wärme2 ;Ränzstraße;2;20000.0;22000.0

;Ränzstraße;12;20000.0;22000.0

;Gedelerstraße;2;20000.0;22000.0 ;Gedelerstraße;4;20000.0;22000.0

;Wilhelminenstraße;19;20000.0;22000.0

;Richterstraße;59;20000.0;22000.0

Sonderkunde1;;;500000.0;480000.0